﻿set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


CREATE PROCEDURE [dbo].[sp_GetUserDataForUserId]
	@UserId				NVARCHAR(256)
AS
BEGIN

	SELECT	 m.[UserId]
			,u.[UserName]
			,m.[Email]
	FROM		[dbo].[aspnet_Membership] m inner join
				[dbo].[aspnet_Users] u ON m.[UserId] = u.[UserId]
	WHERE		u.[UserId] = @UserId

END

